package com.example.trackcircuitdiagnosis.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.trackcircuitdiagnosis.entity.DeviceInformationEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 23639
* @description 针对表【device_information(设备详细信息表)】的数据库操作Mapper
* @createDate 2023-12-01 21:16:29
* @Entity com.example.trackcircuitdiagnosis.entity.DeviceInformation
*/
@Mapper
public interface DeviceInformationMapper extends BaseMapper<DeviceInformationEntity> {


    @Select("select * from device_information as d where d.did in (select device.did from device where mid  =#{mid}) ")
    List<DeviceInformationEntity> findDeviceInformationAll(Integer mid);


}




